OpenEdge Data Management:<br />Database Administration Database restore examples

This section includes examples of database restores using PROREST. The examples use UNIX. For Windows, the only difference is the format of drive specification.

Full backup restore example

The database administrator of Company X’s Development department wants to restore the devel.db database that was previously backed up.

Enter the following command:


prorest newdev /dev/rrm/0m

The newdev.db database is an empty database. The 9-track tape drive (/dev/rrm/0m) specifies the device from which the full backup is being restored. As the restore begins, the following report appears:

This is a full backup of /usr1/develop/devel.db. (6759) This backup was taken Wed Nov 18 15:34:43 1999. (6760) The blocksize is 1024. (6990) It will require a minimum of 3065 blocks to restore. (6763) Read 41 blocks in 00:00:02

This is a full backup of /usr1/develop/devel.db. (6759) 
This backup was taken Wed Nov 18 15:34:43 1999. (6760) 
The blocksize is 1024. (6990) 
It will require a minimum of 3065 blocks to restore. (6763) 
Read 41 blocks in 00:00:02

This command restores the database devel.db from a tape to newdev.db. The report indicates that volume 1 is being processed.

Connect to newdev.db once the restore is complete.

Incremental backup restore example

If you want to restore an incremental backup of the devel.db database to a new database, you must first restore a full backup.

Enter the following command to run an incremental restore of the database from a tape once the full restore is done:


prorest newdev /dev/rrm/0m

The following report appears as the restore begins:

This is an incremental backup of /usr1/develop/devel.db. (6759) This backup was taken Wed Nov 18 15:41:47 1999. (6760) The blocksize is 1024. (6990) It is based on the full backup of Wed Nov 18 15:34:43 1999. (6761) It will require a minimum of 3065 blocks to restore. (6763) Read 41 blocks in 00:00:00

This is an incremental backup of /usr1/develop/devel.db. (6759) 
This backup was taken Wed Nov 18 15:41:47 1999. (6760) 
The blocksize is 1024. (6990) 
It is based on the full backup of Wed Nov 18 15:34:43 1999. (6761) 
It will require a minimum of 3065 blocks to restore. (6763) 
Read 41 blocks in 00:00:00

Once the restore is complete, connect to newdev.db.